Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
PositionID (FK)(PK) | A unique identifier for a specific Position. This may or may not be controlled by a centralized HR function. | ID_PST | Identity | integer | Position(CO_PST) |
WorkerID (FK)(PK) | A unique system-assigned identifier for the Person who is a particular Worker. | ID_WRKR | Identity | integer | Worker(PA_WRKR) |
EffectiveDate (PK) | The date that an EMPLOYEE ASSIGMENT is first valid. | DC_EF | EffectiveDate | date | |
StatusCode | A code that represents the current state of a WorkerAssignment. | SC_EM_ASGMT | Code2Status | char(2) | |
ExpirationDate | The date that an employee's assignment is no longer valid. | DC_EP | ExpirationDate | date | |
Title | The title the Worker held while assigned to the nominated Position. e.g. Sporting Goods Department Manager | NM_TTL | Name | varchar(40) | |
FullTimeFlag | A flag recording wether or not the nominated Worker in this Position worked a mandated 37.5 or 40 hours per-week. | FL_TM_FL | Flag | integer | |
SalaryFlag | A flag recording wether or not the nominated Worker in the nominated Position was paid a Salary or per time period. | FL_SLRY | Flag | integer | |
OvertimeExemptFlag | A flag recording wether or not the nominated Worker in the nominated Position was exempt from working overtime. | FL_EXM_OVR_TM | Flag | integer | |
PenalRateFlag | A flag recording wether or not the nominated Worker in the nominated Position was paid a penal rate for working overtime. Sometimes referred to as OvertimeEligibileFlag. | FL_RTE_PNL | Flag | integer | |
CommissionFlag | A flag recording wether or not the nominated Worker in the nominated Position was paid commission on the sales that they made. | FL_CMN | Flag | integer | |
PayPeriodCode | A retailer assigned code denoting the pay period for the nominated Worker in the nominated Position. e.g. Hour, Week, Month, Year | CD_PRD_PY | Code4 | char(4) | |
PayRate | A monetary amount being the amount paid per PayPeriod to the nominated Worker in the nominated Position. | MO_RTE_PY | Money | decimal(16,5) | |